Federal

select * from tb_web_taxonomy with (nolock) where upper(web_url)=? and site = 'sportsman'

SELECT distinct b.style_id
    FROM tb_term_sale_entries b with (nolock) LEFT JOIN tb_term_sales a with (nolock) ON (a.term_sale_id=b.term_sale_id)
    WHERE b.start_date<= '2024-05-20 14:00:00' AND b.end_date >= '2024-05-20 14:00:00' AND b.store_id=10

SELECT * 
	FROM tb_mfg_promo.dbo.tb_pkg a with (nolock)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id) 
	WHERE 
	b.main_id is not NULL 
	and a.start_date<= '05/20/2024 23:59:00' and a.end_date >= '05/20/2024'
	
	and a.site='sportsman'

select * from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock)

SELECT a.styles_web_taxonomy_id,max(a.style_id) as style_id,max(a.style) as style,max(a.web_style) as web_style,max(a.description) as web_desc,max(a.web_desc) as web_description,max(a.web_long_desc) as web_long_desc,max(a.picture_id) as picture_id,max(a.sort_position) as prod_sort_position,max(a.dept) as dept,max(a.typ) as typ,max(a.subtyp_1) as subtyp_1,max(a.subtyp_2) as subtyp_2,max(a.subtyp_3) as subtyp_3,max(a.category_style) as category_style,max(a.web_url) as web_url,max(a.sort_position) as sort_position,max(a.web_taxonomy_id) as web_taxonomy_id,max(a.brand) as brand,max(a.date_entered) as date_entered,max(a.non_invt) as non_invt,max(a.overnight_required) as overnight_required,max(a.is_firearm) as is_firearm,max(a.of1) as of1,max(a.of2) as of2,max(a.of3) as of3,max(a.of4) as of4,max(a.of5) as of5,max(a.of6) as of6,max(a.of7) as of7,max(a.of8) as of8,max(a.of9) as of9,max(a.of10) as of10,max(a.of11) as of11,max(a.of12) as of12,max(a.of13) as of13,max(a.of14) as of14,max(a.of15) as of15,max(a.of16) as of16,max(a.of17) as of17,max(a.of18) as of18,max(a.of19) as of19,max(a.of20) as of20
,min(c.price) as min_price,min(c.store_price) as store_price,max(c.sugg_price) as max_price,min(c.wholesale_price) as vipprice,max(c.qoh) as qoh,max(c.qc) as qc,max(c.qs) as qs,sum(qoh + qc) as available,sum(c.qs - c.qc) as sold,max(c.sugg_price) AS max_sugg_price,avg(CASE WHEN qq.of9 IS NULL OR qq.of9 = '' THEN 0 ELSE c.price / qq.of9 END) as round
	
 FROM web_all_products a WITH (NOLOCK)
 INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
 INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
 INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
 INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
	
	
 WHERE a.style_id > 0 and (a.of20='SPORTS' or a.of20='BOTH' or a.of20 = 'SPORTSOUTDOORS') and a.picture_id > 0
and qq.web_product='Y' and c.store_id=10 
	 and a.brand='FEDERAL AMMUNITION'
	
	group by a.styles_web_taxonomy_id

select
		distinct
		(style_id) as style_id
		, max(picture_id)
			,	min(min_price) as min_price
			,	max(max_price) as max_price
			,	min(vipprice) as vipprice
			,	max(web_style) as web_style
            ,	max(style) as style
			,	max(web_desc) as web_desc
            ,	max(web_description) as web_description
			,	max(picture_id) as picture_id
            ,	max(web_long_desc) as web_long_desc
			,   max(dept) as dept
			,   max(qoh) as qoh
			,	max(qc) as qc
			,	max(qs) as qs
			,	max(of18) as of18
			,	max(of17) as of17
			,	max(of15) as of15
            ,	max(of12) as of12
    		,	max(of10) as of10
    		,	max(of9) as of9
    		,	max(of8) as of8
			,	max(of7) as of7
    		,	max(of6) as of6
    		,	max(of5) as of5
            ,	max(of4) as of4
    		,	max(of3) as of3
            ,	max(of2) as of2
            ,	max(of1) as of1
			,	max(available) as available
            ,	max(available) as sold
			,   max(typ) as typ
            ,	max(round) as round
            ,	max(non_invt) as non_invt
			,	max(overnight_required) as overnight_required
			,   max(subtyp_1) as subtyp_1
			,   max(subtyp_2) as subtyp_2
			,   max(subtyp_3) as subtyp_3
			,   max(category_style) as category_style
		     ,   max(sort_position) as sort_position
		     ,max(brand) as brand
	,	MAX(max_sugg_price) AS max_sugg_price
    

		from grandgetproducts
		where
		 style_id is not null
            
				and brand='FEDERAL AMMUNITION'
			


group by Style_id order by
min_price desc

select * from grandgetproducts
		where
		 picture_id is not null
            
			
				and brand='FEDERAL AMMUNITION'
			


order by

min_price

select dept, web_url ,sort_position, category_style from tb_web_taxonomy with (nolock) where typ='EMPTY' and dept<>'EMPTY' and dept='' and site = 'sportsman' order by sort_position

select distinct(brand) as brand from GetProducts

select distinct a.spec_value from tb_mfg_promo.dbo.item_spec_values a left join tb_mfg_promo.dbo.item_spec_names b on (a.spec_id=b.spec_id) left join tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id) where b.spec_name = 'Product Line' and c.style_id in (250301,70176,126495,161767,252084,185655,264214,136929,84984,264215,93253,107912,111415,128504,128508,250064,195437,108156,141302,246735,246736,126491,250904,254320,126694,252943,254592,252486,254118,254119,254870,252489,127582,205594,269496,173782,277167,163470,158373,264221,128510,172058,136932,186728,128325,202739,117166,164083,205917,262127,133409,137592,219949,246731,252770,219951,298836,269099,116342,124705,251191,261335,74734,87327,168323,249932,262122,262123,262129,168322,291163,137551,166594,74728,74730,74732,255699,262124,290162,249063,291023,74711,74724,114261,168320,178931,202659,207032,207035,250066,250068,251033,251745,110336,140022,85475,168321,186736,291606,74704,74708,74715,74718,74721,140006,179671,208083,250067,202658,19383,208363,218588,223149,233345,266302,272160,19081,101902,163721,202725,204611,209502,219952,222132,290956,202660,19375,125640,140170,202661,202734,209500,219950,249933,297988,19413,136859,163722,223155,306687,19294,79919,202728,202664,209504,250057,19221,19239,19402,19422,70737,125053,155808,185591,185602,198451,207036,207037,252740,261190,267103,268922,301579,136843,204612,209503,252756,19373,246661,19238,133413,163723,164589,218020,219957,250035,295085,19177,104501,250030,292871,19379,122804,136845,168317,219953,219954,19053,19249,77464,204607,250042,250046,218030,219955,19170,19397,19408,19412,19434,76677,78583,103831,136873,181254,185560,193654,197134,205631,209501,218025,246732,249704,249706,250031,250034,250037,250043,250048,261334,266164,284677,296427,296428,111460,19427,219956,250044,19108,19368,77461,218041,249702,250047,284379,284646,292872,138067,168318,168319,196282,218021,223152,223170,19077,19421,19424,119852,125642,150576,163720,179664,218034,219958,219959,219960,293504,19084,19355,19406,19440,172054,179672,185559,185601,202718,216779,218017,218031,218501,250028,250061,250062,291613,92468,95505,168309,202733,210201,218028,292389,292634,19070,19071,19101,19380,19405,129233,136846,185593,186732,218043,218044,250041,260840,261189,19166,78584,185566,186733,193659,250029,298608,19061,19080,139881,218019,218027,19069,19097,19167,19217,19218,19222,19330,19342,19416,19446,19448,75367,97539,100867,161435,168315,172060,185561,202666,202716,204591,249703,251229,280314,300990,306683,306903,198537,19102,19104,19344,19361,185567,185568,185569,198058,202730,204605,218032,218035,218046,220480,250027,256185,288606,294860,296272,188851,19086,19341,19423,74579,135377,150577,153282,165159,168307,168308,168311,168312,181258,192262,218042,249705,294857,19063,19169,19191,19192,19343,136876,163719,168314,181256,185594,252763,19223,181257,185562,185563,193286,193670,202717,202721,202729,181167,19089,19158,19168,19189,19226,19227,19340,70713,79364,80152,87356,90275,109273,150415,152577,161437,172606,185592,191742,191924,193665,202668,202715,202731,204602,218022,218023,218038,220605,220679,223151,249939,250477,250478,252720,252721,252722,252723,252737,252738,252857,266771,276024,284425,290187,300496,122144,168313,185577,193668,202683,218018,218024,218026,218049,19033,19190,19250,19377,19399,19443,108378,115166,168316,181154,185578,193658,202670,202671,202682,204601,223150,273511,290167,292296,295084,300921,306798,19042,19391,103590,136869,144803,185598,193653,193667,201973,202712,220606,193287,19216,19356,19364,19365,136927,186729,198059,204598,250485,292217,292218,19349,19219,19220,19228,19231,19237,19296,19336,19354,19388,19439,70089,70715,94740,101905,108374,118885,122230,128284,136848,136851,150414,151609,161447,163718,168306,168324,168326,170064,175295,181251,181940,184047,185574,185575,185603,185605,191741,193660,193661,193662,198017,198069,202672,202996,204589,207242,208357,214524,220583,223158,250038,250051,250490,250498,251188,252760,252838,252855,253513,253514,255964,260632,269854,273464,281640,293164,298606,298835,302479,19056,19164,19224,19362,185572,202713,223168,250484,250495,252761,19163,19401,162875,223171,19076,19232,90832,122142,136905,148138,150581,165522,181255,185590,193666,246660,252759,252765,262406,297720,306679,19302,19099,19172,19173,19248,75984,92469,120234,181253,185589,193652,202736,218502,250474,250491,250497,252764,285008,291428,292320,298604,19040,19165,19225,19395,19410,19442,148364,161442,163715,165521,168789,168790,168791,185585,185606,193671,202669,222129,249955,252728,195751,19088,19160,19282,19283,19286,19287,19300,19335,19430,76668,89028,92470,98468,107925,108375,111453,112961,134455,136836,137326,147205,160828,161434,161440,170055,181950,181952,184552,185571,185573,185607,185612,185613,189359,191743,193663,193664,201196,202700,202719,209608,214611,218033,218500,222474,249960,249987,250479,251034,252726,252766,252768,252840,252848,254319,254363,264594,273459,291607,307595,70747,70748,19444,19039,19049,19051,19058,19178,19187,19229,19381,19400,91669,92299,127080,127959,202674,202675,202677,220584,250487,250494,19067,19072,19074,19157,19171,19176,19284,19285,19359,19441,95822,179674,202673,202686,202692,250480,298172,220582,132670,101907,19035,19065,19215,19261,19333,120235,136865,161128,172052,179676,185587,186730,198018,198032,202679,202695,204593,289519,132672,63671,19175,77459,150582,202667,251269,262137,273465,306799,252769,70168,19096,19259,19262,19263,19264,19278,19279,19281,19315,19322,66543,70728,70730,101950,101951,140004,170067,181259,198029,202492,202688,202738,203577,207361,207828,214580,217507,217508,250489,252752,252843,252845,252850,252852,252856,283687,296287,63670,63672,202684,223169,185565,19037,75990,101904,101906,179675,202687,202689,202690,202691,202699,202701,249733,250055,297507,298206,126729,126733,129606,198020,127478,19188,19347,19269,19348,19418,75451,129685,185604,200554,214625,218016,219610,250053,298829,92298,19161,19180,19181,19260,19265,19271,19272,19419,185610,202714,202995,204592,214626,252733,282091,307596,223061,70749,70750,101943,101945,101946,119937,185609,198799,202693,202694,202696,202711,250050,250052,19098,19280,19292,19420,19432,19437,85875,101935,101952,113943,119935,125311,132650,132652,168783,189364,217650,251097,300928,185570,70751,67679,202703,19093,19201,19276,103830,198057,209597,252735,270975,217505,217506,158851,99243,19162,19203,19204,19211,19230,19256,19258,89781,115141,123772,168775,201200,211280,261332,261333,266937,170530,19199,19200,19277,101944,168784,168787,201193,207243,207244,216501,120236,202685,101948,19273,19305,19311,97434,119936,203671,211278,215945,262056,273514,286909,202676,202678,120298,19195,19198,19202,19210,19438,70719,75310,75331,125997,126513,163327,198008,209599,217503,226021,250019,260610,293137,306806,70721,19207,19436,70207,75311,75323,75326,75328,75334,98896,103481,109120,162514,192835,192836,192837,195906,195907,207503,207557,215944,217499,217500,217501,250551,202704,19196,19197,19209,19299,75321,196413,215946,277587,281316,19208,90618,90922,98706,102364,105795,105797,105803,110331,135034,135279,135281,135317,135426,136823,147963,185608,207501,281318,19312,92987,74725,77493,85904,209059,209060,219788,260611,263711,287245,19159,161444,210125,210128)

select distinct (dept) as dept from getproducts1 where brand='FEDERAL AMMUNITION' group by dept

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Ammo' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 2 and c.style_id in (250301,70176,126495,161767,252084,185655,264214,136929,84984,264215,93253,107912,111415,128504,128508,250064,195437,108156,141302,246735,246736,126491,250904,254320,126694,252943,254592,252486,254118,254119,254870,252489,127582,205594,269496,173782,277167,163470,158373,264221,128510,172058,136932,186728,128325,202739,117166,164083,205917,262127,133409,137592,219949,246731,252770,219951,298836,269099,116342,124705,251191,261335,74734,87327,168323,249932,262122,262123,262129,168322,291163,137551,166594,74728,74730,74732,255699,262124,290162,249063,291023,74711,74724,114261,168320,178931,202659,207032,207035,250066,250068,251033,251745,110336,140022,85475,168321,186736,291606,74704,74708,74715,74718,74721,140006,179671,208083,250067,202658,19383,208363,218588,223149,233345,266302,272160,19081,101902,163721,202725,204611,209502,219952,222132,290956,202660,19375,125640,140170,202661,202734,209500,219950,249933,297988,19413,136859,163722,223155,306687,19294,79919,202728,202664,209504,250057,19221,19239,19402,19422,70737,125053,155808,185591,185602,198451,207036,207037,252740,261190,267103,268922,301579,136843,204612,209503,252756,19373,246661,19238,133413,163723,164589,218020,219957,250035,295085,19177,104501,250030,292871,19379,122804,136845,168317,219953,219954,19053,19249,77464,204607,250042,250046,218030,219955,19170,19397,19408,19412,19434,76677,78583,103831,136873,181254,185560,193654,197134,205631,209501,218025,246732,249704,249706,250031,250034,250037,250043,250048,261334,266164,284677,296427,296428,111460,19427,219956,250044,19108,19368,77461,218041,249702,250047,284379,284646,292872,138067,168318,168319,196282,218021,223152,223170,19077,19421,19424,119852,125642,150576,163720,179664,218034,219958,219959,219960,293504,19084,19355,19406,19440,172054,179672,185559,185601,202718,216779,218017,218031,218501,250028,250061,250062,291613,92468,95505,168309,202733,210201,218028,292389,292634,19070,19071,19101,19380,19405,129233,136846,185593,186732,218043,218044,250041,260840,261189,19166,78584,185566,186733,193659,250029,298608,19061,19080,139881,218019,218027,19069,19097,19167,19217,19218,19222,19330,19342,19416,19446,19448,75367,97539,100867,161435,168315,172060,185561,202666,202716,204591,249703,251229,280314,300990,306683,306903,198537,19102,19104,19344,19361,185567,185568,185569,198058,202730,204605,218032,218035,218046,220480,250027,256185,288606,294860,296272,188851,19086,19341,19423,74579,135377,150577,153282,165159,168307,168308,168311,168312,181258,192262,218042,249705,294857,19063,19169,19191,19192,19343,136876,163719,168314,181256,185594,252763,19223,181257,185562,185563,193286,193670,202717,202721,202729,181167,19089,19158,19168,19189,19226,19227,19340,70713,79364,80152,87356,90275,109273,150415,152577,161437,172606,185592,191742,191924,193665,202668,202715,202731,204602,218022,218023,218038,220605,220679,223151,249939,250477,250478,252720,252721,252722,252723,252737,252738,252857,266771,276024,284425,290187,300496,122144,168313,185577,193668,202683,218018,218024,218026,218049,19033,19190,19250,19377,19399,19443,108378,115166,168316,181154,185578,193658,202670,202671,202682,204601,223150,273511,290167,292296,295084,300921,306798,19042,19391,103590,136869,144803,185598,193653,193667,201973,202712,220606,193287,19216,19356,19364,19365,136927,186729,198059,204598,250485,292217,292218,19349,19219,19220,19228,19231,19237,19296,19336,19354,19388,19439,70089,70715,94740,101905,108374,118885,122230,128284,136848,136851,150414,151609,161447,163718,168306,168324,168326,170064,175295,181251,181940,184047,185574,185575,185603,185605,191741,193660,193661,193662,198017,198069,202672,202996,204589,207242,208357,214524,220583,223158,250038,250051,250490,250498,251188,252760,252838,252855,253513,253514,255964,260632,269854,273464,281640,293164,298606,298835,302479,19056,19164,19224,19362,185572,202713,223168,250484,250495,252761,19163,19401,162875,223171,19076,19232,90832,122142,136905,148138,150581,165522,181255,185590,193666,246660,252759,252765,262406,297720,306679,19302,19099,19172,19173,19248,75984,92469,120234,181253,185589,193652,202736,218502,250474,250491,250497,252764,285008,291428,292320,298604,19040,19165,19225,19395,19410,19442,148364,161442,163715,165521,168789,168790,168791,185585,185606,193671,202669,222129,249955,252728,195751,19088,19160,19282,19283,19286,19287,19300,19335,19430,76668,89028,92470,98468,107925,108375,111453,112961,134455,136836,137326,147205,160828,161434,161440,170055,181950,181952,184552,185571,185573,185607,185612,185613,189359,191743,193663,193664,201196,202700,202719,209608,214611,218033,218500,222474,249960,249987,250479,251034,252726,252766,252768,252840,252848,254319,254363,264594,273459,291607,307595,70747,70748,19444,19039,19049,19051,19058,19178,19187,19229,19381,19400,91669,92299,127080,127959,202674,202675,202677,220584,250487,250494,19067,19072,19074,19157,19171,19176,19284,19285,19359,19441,95822,179674,202673,202686,202692,250480,298172,220582,132670,101907,19035,19065,19215,19261,19333,120235,136865,161128,172052,179676,185587,186730,198018,198032,202679,202695,204593,289519,132672,63671,19175,77459,150582,202667,251269,262137,273465,306799,252769,70168,19096,19259,19262,19263,19264,19278,19279,19281,19315,19322,66543,70728,70730,101950,101951,140004,170067,181259,198029,202492,202688,202738,203577,207361,207828,214580,217507,217508,250489,252752,252843,252845,252850,252852,252856,283687,296287,63670,63672,202684,223169,185565,19037,75990,101904,101906,179675,202687,202689,202690,202691,202699,202701,249733,250055,297507,298206,126729,126733,129606,198020,127478,19188,19347,19269,19348,19418,75451,129685,185604,200554,214625,218016,219610,250053,298829,92298,19161,19180,19181,19260,19265,19271,19272,19419,185610,202714,202995,204592,214626,252733,282091,307596,223061,70749,70750,101943,101945,101946,119937,185609,198799,202693,202694,202696,202711,250050,250052,19098,19280,19292,19420,19432,19437,85875,101935,101952,113943,119935,125311,132650,132652,168783,189364,217650,251097,300928,185570,70751,67679,202703,19093,19201,19276,103830,198057,209597,252735,270975,217505,217506,158851,99243,19162,19203,19204,19211,19230,19256,19258,89781,115141,123772,168775,201200,211280,261332,261333,266937,170530,19199,19200,19277,101944,168784,168787,201193,207243,207244,216501,120236,202685,101948,19273,19305,19311,97434,119936,203671,211278,215945,262056,273514,286909,202676,202678,120298,19195,19198,19202,19210,19438,70719,75310,75331,125997,126513,163327,198008,209599,217503,226021,250019,260610,293137,306806,70721,19207,19436,70207,75311,75323,75326,75328,75334,98896,103481,109120,162514,192835,192836,192837,195906,195907,207503,207557,215944,217499,217500,217501,250551,202704,19196,19197,19209,19299,75321,196413,215946,277587,281316,19208,90618,90922,98706,102364,105795,105797,105803,110331,135034,135279,135281,135317,135426,136823,147963,185608,207501,281318,19312,92987,74725,77493,85904,209059,209060,219788,260611,263711,287245,19159,161444,210125,210128)

select distinct typ from getproducts1 where dept='Ammo' and brand='FEDERAL AMMUNITION' group by typ order by sort_position

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 17 and c.style_id in (250301,70176,126495,161767,252084,185655,264214,136929,84984,264215,93253,107912,111415,128504,128508,250064,195437,108156,141302,246735,246736,126491,250904,254320,126694,252943,254592,252486,254118,254119,254870,252489,127582,205594,269496,173782,277167,163470,158373,264221,128510,172058,136932,186728,128325,202739,117166,164083,205917,262127,133409,137592,219949,246731,252770,219951,298836,269099,116342,124705,251191,261335,74734,87327,168323,249932,262122,262123,262129,168322,291163,137551,166594,74728,74730,74732,255699,262124,290162,249063,291023,74711,74724,114261,168320,178931,202659,207032,207035,250066,250068,251033,251745,110336,140022,85475,168321,186736,291606,74704,74708,74715,74718,74721,140006,179671,208083,250067,202658,19383,208363,218588,223149,233345,266302,272160,19081,101902,163721,202725,204611,209502,219952,222132,290956,202660,19375,125640,140170,202661,202734,209500,219950,249933,297988,19413,136859,163722,223155,306687,19294,79919,202728,202664,209504,250057,19221,19239,19402,19422,70737,125053,155808,185591,185602,198451,207036,207037,252740,261190,267103,268922,301579,136843,204612,209503,252756,19373,246661,19238,133413,163723,164589,218020,219957,250035,295085,19177,104501,250030,292871,19379,122804,136845,168317,219953,219954,19053,19249,77464,204607,250042,250046,218030,219955,19170,19397,19408,19412,19434,76677,78583,103831,136873,181254,185560,193654,197134,205631,209501,218025,246732,249704,249706,250031,250034,250037,250043,250048,261334,266164,284677,296427,296428,111460,19427,219956,250044,19108,19368,77461,218041,249702,250047,284379,284646,292872,138067,168318,168319,196282,218021,223152,223170,19077,19421,19424,119852,125642,150576,163720,179664,218034,219958,219959,219960,293504,19084,19355,19406,19440,172054,179672,185559,185601,202718,216779,218017,218031,218501,250028,250061,250062,291613,92468,95505,168309,202733,210201,218028,292389,292634,19070,19071,19101,19380,19405,129233,136846,185593,186732,218043,218044,250041,260840,261189,19166,78584,185566,186733,193659,250029,298608,19061,19080,139881,218019,218027,19069,19097,19167,19217,19218,19222,19330,19342,19416,19446,19448,75367,97539,100867,161435,168315,172060,185561,202666,202716,204591,249703,251229,280314,300990,306683,306903,198537,19102,19104,19344,19361,185567,185568,185569,198058,202730,204605,218032,218035,218046,220480,250027,256185,288606,294860,296272,188851,19086,19341,19423,74579,135377,150577,153282,165159,168307,168308,168311,168312,181258,192262,218042,249705,294857,19063,19169,19191,19192,19343,136876,163719,168314,181256,185594,252763,19223,181257,185562,185563,193286,193670,202717,202721,202729,181167,19089,19158,19168,19189,19226,19227,19340,70713,79364,80152,87356,90275,109273,150415,152577,161437,172606,185592,191742,191924,193665,202668,202715,202731,204602,218022,218023,218038,220605,220679,223151,249939,250477,250478,252720,252721,252722,252723,252737,252738,252857,266771,276024,284425,290187,300496,122144,168313,185577,193668,202683,218018,218024,218026,218049,19033,19190,19250,19377,19399,19443,108378,115166,168316,181154,185578,193658,202670,202671,202682,204601,223150,273511,290167,292296,295084,300921,306798,19042,19391,103590,136869,144803,185598,193653,193667,201973,202712,220606,193287,19216,19356,19364,19365,136927,186729,198059,204598,250485,292217,292218,19349,19219,19220,19228,19231,19237,19296,19336,19354,19388,19439,70089,70715,94740,101905,108374,118885,122230,128284,136848,136851,150414,151609,161447,163718,168306,168324,168326,170064,175295,181251,181940,184047,185574,185575,185603,185605,191741,193660,193661,193662,198017,198069,202672,202996,204589,207242,208357,214524,220583,223158,250038,250051,250490,250498,251188,252760,252838,252855,253513,253514,255964,260632,269854,273464,281640,293164,298606,298835,302479,19056,19164,19224,19362,185572,202713,223168,250484,250495,252761,19163,19401,162875,223171,19076,19232,90832,122142,136905,148138,150581,165522,181255,185590,193666,246660,252759,252765,262406,297720,306679,19302,19099,19172,19173,19248,75984,92469,120234,181253,185589,193652,202736,218502,250474,250491,250497,252764,285008,291428,292320,298604,19040,19165,19225,19395,19410,19442,148364,161442,163715,165521,168789,168790,168791,185585,185606,193671,202669,222129,249955,252728,195751,19088,19160,19282,19283,19286,19287,19300,19335,19430,76668,89028,92470,98468,107925,108375,111453,112961,134455,136836,137326,147205,160828,161434,161440,170055,181950,181952,184552,185571,185573,185607,185612,185613,189359,191743,193663,193664,201196,202700,202719,209608,214611,218033,218500,222474,249960,249987,250479,251034,252726,252766,252768,252840,252848,254319,254363,264594,273459,291607,307595,70747,70748,19444,19039,19049,19051,19058,19178,19187,19229,19381,19400,91669,92299,127080,127959,202674,202675,202677,220584,250487,250494,19067,19072,19074,19157,19171,19176,19284,19285,19359,19441,95822,179674,202673,202686,202692,250480,298172,220582,132670,101907,19035,19065,19215,19261,19333,120235,136865,161128,172052,179676,185587,186730,198018,198032,202679,202695,204593,289519,132672,63671,19175,77459,150582,202667,251269,262137,273465,306799,252769,70168,19096,19259,19262,19263,19264,19278,19279,19281,19315,19322,66543,70728,70730,101950,101951,140004,170067,181259,198029,202492,202688,202738,203577,207361,207828,214580,217507,217508,250489,252752,252843,252845,252850,252852,252856,283687,296287,63670,63672,202684,223169,185565,19037,75990,101904,101906,179675,202687,202689,202690,202691,202699,202701,249733,250055,297507,298206,126729,126733,129606,198020,127478,19188,19347,19269,19348,19418,75451,129685,185604,200554,214625,218016,219610,250053,298829,92298,19161,19180,19181,19260,19265,19271,19272,19419,185610,202714,202995,204592,214626,252733,282091,307596,223061,70749,70750,101943,101945,101946,119937,185609,198799,202693,202694,202696,202711,250050,250052,19098,19280,19292,19420,19432,19437,85875,101935,101952,113943,119935,125311,132650,132652,168783,189364,217650,251097,300928,185570,70751,67679,202703,19093,19201,19276,103830,198057,209597,252735,270975,217505,217506,158851,99243,19162,19203,19204,19211,19230,19256,19258,89781,115141,123772,168775,201200,211280,261332,261333,266937,170530,19199,19200,19277,101944,168784,168787,201193,207243,207244,216501,120236,202685,101948,19273,19305,19311,97434,119936,203671,211278,215945,262056,273514,286909,202676,202678,120298,19195,19198,19202,19210,19438,70719,75310,75331,125997,126513,163327,198008,209599,217503,226021,250019,260610,293137,306806,70721,19207,19436,70207,75311,75323,75326,75328,75334,98896,103481,109120,162514,192835,192836,192837,195906,195907,207503,207557,215944,217499,217500,217501,250551,202704,19196,19197,19209,19299,75321,196413,215946,277587,281316,19208,90618,90922,98706,102364,105795,105797,105803,110331,135034,135279,135281,135317,135426,136823,147963,185608,207501,281318,19312,92987,74725,77493,85904,209059,209060,219788,260611,263711,287245,19159,161444,210125,210128)

select distinct typ from getproducts1 where dept='Firearm Accessories' and brand='FEDERAL AMMUNITION' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Firearm Accessories' and typ='Ammo Storage' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 29 and c.style_id in (250301,70176,126495,161767,252084,185655,264214,136929,84984,264215,93253,107912,111415,128504,128508,250064,195437,108156,141302,246735,246736,126491,250904,254320,126694,252943,254592,252486,254118,254119,254870,252489,127582,205594,269496,173782,277167,163470,158373,264221,128510,172058,136932,186728,128325,202739,117166,164083,205917,262127,133409,137592,219949,246731,252770,219951,298836,269099,116342,124705,251191,261335,74734,87327,168323,249932,262122,262123,262129,168322,291163,137551,166594,74728,74730,74732,255699,262124,290162,249063,291023,74711,74724,114261,168320,178931,202659,207032,207035,250066,250068,251033,251745,110336,140022,85475,168321,186736,291606,74704,74708,74715,74718,74721,140006,179671,208083,250067,202658,19383,208363,218588,223149,233345,266302,272160,19081,101902,163721,202725,204611,209502,219952,222132,290956,202660,19375,125640,140170,202661,202734,209500,219950,249933,297988,19413,136859,163722,223155,306687,19294,79919,202728,202664,209504,250057,19221,19239,19402,19422,70737,125053,155808,185591,185602,198451,207036,207037,252740,261190,267103,268922,301579,136843,204612,209503,252756,19373,246661,19238,133413,163723,164589,218020,219957,250035,295085,19177,104501,250030,292871,19379,122804,136845,168317,219953,219954,19053,19249,77464,204607,250042,250046,218030,219955,19170,19397,19408,19412,19434,76677,78583,103831,136873,181254,185560,193654,197134,205631,209501,218025,246732,249704,249706,250031,250034,250037,250043,250048,261334,266164,284677,296427,296428,111460,19427,219956,250044,19108,19368,77461,218041,249702,250047,284379,284646,292872,138067,168318,168319,196282,218021,223152,223170,19077,19421,19424,119852,125642,150576,163720,179664,218034,219958,219959,219960,293504,19084,19355,19406,19440,172054,179672,185559,185601,202718,216779,218017,218031,218501,250028,250061,250062,291613,92468,95505,168309,202733,210201,218028,292389,292634,19070,19071,19101,19380,19405,129233,136846,185593,186732,218043,218044,250041,260840,261189,19166,78584,185566,186733,193659,250029,298608,19061,19080,139881,218019,218027,19069,19097,19167,19217,19218,19222,19330,19342,19416,19446,19448,75367,97539,100867,161435,168315,172060,185561,202666,202716,204591,249703,251229,280314,300990,306683,306903,198537,19102,19104,19344,19361,185567,185568,185569,198058,202730,204605,218032,218035,218046,220480,250027,256185,288606,294860,296272,188851,19086,19341,19423,74579,135377,150577,153282,165159,168307,168308,168311,168312,181258,192262,218042,249705,294857,19063,19169,19191,19192,19343,136876,163719,168314,181256,185594,252763,19223,181257,185562,185563,193286,193670,202717,202721,202729,181167,19089,19158,19168,19189,19226,19227,19340,70713,79364,80152,87356,90275,109273,150415,152577,161437,172606,185592,191742,191924,193665,202668,202715,202731,204602,218022,218023,218038,220605,220679,223151,249939,250477,250478,252720,252721,252722,252723,252737,252738,252857,266771,276024,284425,290187,300496,122144,168313,185577,193668,202683,218018,218024,218026,218049,19033,19190,19250,19377,19399,19443,108378,115166,168316,181154,185578,193658,202670,202671,202682,204601,223150,273511,290167,292296,295084,300921,306798,19042,19391,103590,136869,144803,185598,193653,193667,201973,202712,220606,193287,19216,19356,19364,19365,136927,186729,198059,204598,250485,292217,292218,19349,19219,19220,19228,19231,19237,19296,19336,19354,19388,19439,70089,70715,94740,101905,108374,118885,122230,128284,136848,136851,150414,151609,161447,163718,168306,168324,168326,170064,175295,181251,181940,184047,185574,185575,185603,185605,191741,193660,193661,193662,198017,198069,202672,202996,204589,207242,208357,214524,220583,223158,250038,250051,250490,250498,251188,252760,252838,252855,253513,253514,255964,260632,269854,273464,281640,293164,298606,298835,302479,19056,19164,19224,19362,185572,202713,223168,250484,250495,252761,19163,19401,162875,223171,19076,19232,90832,122142,136905,148138,150581,165522,181255,185590,193666,246660,252759,252765,262406,297720,306679,19302,19099,19172,19173,19248,75984,92469,120234,181253,185589,193652,202736,218502,250474,250491,250497,252764,285008,291428,292320,298604,19040,19165,19225,19395,19410,19442,148364,161442,163715,165521,168789,168790,168791,185585,185606,193671,202669,222129,249955,252728,195751,19088,19160,19282,19283,19286,19287,19300,19335,19430,76668,89028,92470,98468,107925,108375,111453,112961,134455,136836,137326,147205,160828,161434,161440,170055,181950,181952,184552,185571,185573,185607,185612,185613,189359,191743,193663,193664,201196,202700,202719,209608,214611,218033,218500,222474,249960,249987,250479,251034,252726,252766,252768,252840,252848,254319,254363,264594,273459,291607,307595,70747,70748,19444,19039,19049,19051,19058,19178,19187,19229,19381,19400,91669,92299,127080,127959,202674,202675,202677,220584,250487,250494,19067,19072,19074,19157,19171,19176,19284,19285,19359,19441,95822,179674,202673,202686,202692,250480,298172,220582,132670,101907,19035,19065,19215,19261,19333,120235,136865,161128,172052,179676,185587,186730,198018,198032,202679,202695,204593,289519,132672,63671,19175,77459,150582,202667,251269,262137,273465,306799,252769,70168,19096,19259,19262,19263,19264,19278,19279,19281,19315,19322,66543,70728,70730,101950,101951,140004,170067,181259,198029,202492,202688,202738,203577,207361,207828,214580,217507,217508,250489,252752,252843,252845,252850,252852,252856,283687,296287,63670,63672,202684,223169,185565,19037,75990,101904,101906,179675,202687,202689,202690,202691,202699,202701,249733,250055,297507,298206,126729,126733,129606,198020,127478,19188,19347,19269,19348,19418,75451,129685,185604,200554,214625,218016,219610,250053,298829,92298,19161,19180,19181,19260,19265,19271,19272,19419,185610,202714,202995,204592,214626,252733,282091,307596,223061,70749,70750,101943,101945,101946,119937,185609,198799,202693,202694,202696,202711,250050,250052,19098,19280,19292,19420,19432,19437,85875,101935,101952,113943,119935,125311,132650,132652,168783,189364,217650,251097,300928,185570,70751,67679,202703,19093,19201,19276,103830,198057,209597,252735,270975,217505,217506,158851,99243,19162,19203,19204,19211,19230,19256,19258,89781,115141,123772,168775,201200,211280,261332,261333,266937,170530,19199,19200,19277,101944,168784,168787,201193,207243,207244,216501,120236,202685,101948,19273,19305,19311,97434,119936,203671,211278,215945,262056,273514,286909,202676,202678,120298,19195,19198,19202,19210,19438,70719,75310,75331,125997,126513,163327,198008,209599,217503,226021,250019,260610,293137,306806,70721,19207,19436,70207,75311,75323,75326,75328,75334,98896,103481,109120,162514,192835,192836,192837,195906,195907,207503,207557,215944,217499,217500,217501,250551,202704,19196,19197,19209,19299,75321,196413,215946,277587,281316,19208,90618,90922,98706,102364,105795,105797,105803,110331,135034,135279,135281,135317,135426,136823,147963,185608,207501,281318,19312,92987,74725,77493,85904,209059,209060,219788,260611,263711,287245,19159,161444,210125,210128)

select distinct typ from getproducts1 where dept='Law Enforcement' and brand='FEDERAL AMMUNITION' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Law Enforcement' and typ='Law Enforcement Ammo' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url, picture_id, web_taxonomy_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Reloading' and typ='EMPTY' and site = 'sportsman'

select distinct a.spec_value 
                                from 
                                    tb_mfg_promo.dbo.item_spec_values a 
                                left join 
                                    tb_web_taxonomy b on (a.spec_dept=b.web_taxonomy_id) 
                                left join 
                                    tb_mfg_promo.dbo.item_specs c on (a.spec_value_id=c.spec_value_id)
                                where 
                                    a.spec_dept = 958 and c.style_id in (250301,70176,126495,161767,252084,185655,264214,136929,84984,264215,93253,107912,111415,128504,128508,250064,195437,108156,141302,246735,246736,126491,250904,254320,126694,252943,254592,252486,254118,254119,254870,252489,127582,205594,269496,173782,277167,163470,158373,264221,128510,172058,136932,186728,128325,202739,117166,164083,205917,262127,133409,137592,219949,246731,252770,219951,298836,269099,116342,124705,251191,261335,74734,87327,168323,249932,262122,262123,262129,168322,291163,137551,166594,74728,74730,74732,255699,262124,290162,249063,291023,74711,74724,114261,168320,178931,202659,207032,207035,250066,250068,251033,251745,110336,140022,85475,168321,186736,291606,74704,74708,74715,74718,74721,140006,179671,208083,250067,202658,19383,208363,218588,223149,233345,266302,272160,19081,101902,163721,202725,204611,209502,219952,222132,290956,202660,19375,125640,140170,202661,202734,209500,219950,249933,297988,19413,136859,163722,223155,306687,19294,79919,202728,202664,209504,250057,19221,19239,19402,19422,70737,125053,155808,185591,185602,198451,207036,207037,252740,261190,267103,268922,301579,136843,204612,209503,252756,19373,246661,19238,133413,163723,164589,218020,219957,250035,295085,19177,104501,250030,292871,19379,122804,136845,168317,219953,219954,19053,19249,77464,204607,250042,250046,218030,219955,19170,19397,19408,19412,19434,76677,78583,103831,136873,181254,185560,193654,197134,205631,209501,218025,246732,249704,249706,250031,250034,250037,250043,250048,261334,266164,284677,296427,296428,111460,19427,219956,250044,19108,19368,77461,218041,249702,250047,284379,284646,292872,138067,168318,168319,196282,218021,223152,223170,19077,19421,19424,119852,125642,150576,163720,179664,218034,219958,219959,219960,293504,19084,19355,19406,19440,172054,179672,185559,185601,202718,216779,218017,218031,218501,250028,250061,250062,291613,92468,95505,168309,202733,210201,218028,292389,292634,19070,19071,19101,19380,19405,129233,136846,185593,186732,218043,218044,250041,260840,261189,19166,78584,185566,186733,193659,250029,298608,19061,19080,139881,218019,218027,19069,19097,19167,19217,19218,19222,19330,19342,19416,19446,19448,75367,97539,100867,161435,168315,172060,185561,202666,202716,204591,249703,251229,280314,300990,306683,306903,198537,19102,19104,19344,19361,185567,185568,185569,198058,202730,204605,218032,218035,218046,220480,250027,256185,288606,294860,296272,188851,19086,19341,19423,74579,135377,150577,153282,165159,168307,168308,168311,168312,181258,192262,218042,249705,294857,19063,19169,19191,19192,19343,136876,163719,168314,181256,185594,252763,19223,181257,185562,185563,193286,193670,202717,202721,202729,181167,19089,19158,19168,19189,19226,19227,19340,70713,79364,80152,87356,90275,109273,150415,152577,161437,172606,185592,191742,191924,193665,202668,202715,202731,204602,218022,218023,218038,220605,220679,223151,249939,250477,250478,252720,252721,252722,252723,252737,252738,252857,266771,276024,284425,290187,300496,122144,168313,185577,193668,202683,218018,218024,218026,218049,19033,19190,19250,19377,19399,19443,108378,115166,168316,181154,185578,193658,202670,202671,202682,204601,223150,273511,290167,292296,295084,300921,306798,19042,19391,103590,136869,144803,185598,193653,193667,201973,202712,220606,193287,19216,19356,19364,19365,136927,186729,198059,204598,250485,292217,292218,19349,19219,19220,19228,19231,19237,19296,19336,19354,19388,19439,70089,70715,94740,101905,108374,118885,122230,128284,136848,136851,150414,151609,161447,163718,168306,168324,168326,170064,175295,181251,181940,184047,185574,185575,185603,185605,191741,193660,193661,193662,198017,198069,202672,202996,204589,207242,208357,214524,220583,223158,250038,250051,250490,250498,251188,252760,252838,252855,253513,253514,255964,260632,269854,273464,281640,293164,298606,298835,302479,19056,19164,19224,19362,185572,202713,223168,250484,250495,252761,19163,19401,162875,223171,19076,19232,90832,122142,136905,148138,150581,165522,181255,185590,193666,246660,252759,252765,262406,297720,306679,19302,19099,19172,19173,19248,75984,92469,120234,181253,185589,193652,202736,218502,250474,250491,250497,252764,285008,291428,292320,298604,19040,19165,19225,19395,19410,19442,148364,161442,163715,165521,168789,168790,168791,185585,185606,193671,202669,222129,249955,252728,195751,19088,19160,19282,19283,19286,19287,19300,19335,19430,76668,89028,92470,98468,107925,108375,111453,112961,134455,136836,137326,147205,160828,161434,161440,170055,181950,181952,184552,185571,185573,185607,185612,185613,189359,191743,193663,193664,201196,202700,202719,209608,214611,218033,218500,222474,249960,249987,250479,251034,252726,252766,252768,252840,252848,254319,254363,264594,273459,291607,307595,70747,70748,19444,19039,19049,19051,19058,19178,19187,19229,19381,19400,91669,92299,127080,127959,202674,202675,202677,220584,250487,250494,19067,19072,19074,19157,19171,19176,19284,19285,19359,19441,95822,179674,202673,202686,202692,250480,298172,220582,132670,101907,19035,19065,19215,19261,19333,120235,136865,161128,172052,179676,185587,186730,198018,198032,202679,202695,204593,289519,132672,63671,19175,77459,150582,202667,251269,262137,273465,306799,252769,70168,19096,19259,19262,19263,19264,19278,19279,19281,19315,19322,66543,70728,70730,101950,101951,140004,170067,181259,198029,202492,202688,202738,203577,207361,207828,214580,217507,217508,250489,252752,252843,252845,252850,252852,252856,283687,296287,63670,63672,202684,223169,185565,19037,75990,101904,101906,179675,202687,202689,202690,202691,202699,202701,249733,250055,297507,298206,126729,126733,129606,198020,127478,19188,19347,19269,19348,19418,75451,129685,185604,200554,214625,218016,219610,250053,298829,92298,19161,19180,19181,19260,19265,19271,19272,19419,185610,202714,202995,204592,214626,252733,282091,307596,223061,70749,70750,101943,101945,101946,119937,185609,198799,202693,202694,202696,202711,250050,250052,19098,19280,19292,19420,19432,19437,85875,101935,101952,113943,119935,125311,132650,132652,168783,189364,217650,251097,300928,185570,70751,67679,202703,19093,19201,19276,103830,198057,209597,252735,270975,217505,217506,158851,99243,19162,19203,19204,19211,19230,19256,19258,89781,115141,123772,168775,201200,211280,261332,261333,266937,170530,19199,19200,19277,101944,168784,168787,201193,207243,207244,216501,120236,202685,101948,19273,19305,19311,97434,119936,203671,211278,215945,262056,273514,286909,202676,202678,120298,19195,19198,19202,19210,19438,70719,75310,75331,125997,126513,163327,198008,209599,217503,226021,250019,260610,293137,306806,70721,19207,19436,70207,75311,75323,75326,75328,75334,98896,103481,109120,162514,192835,192836,192837,195906,195907,207503,207557,215944,217499,217500,217501,250551,202704,19196,19197,19209,19299,75321,196413,215946,277587,281316,19208,90618,90922,98706,102364,105795,105797,105803,110331,135034,135279,135281,135317,135426,136823,147963,185608,207501,281318,19312,92987,74725,77493,85904,209059,209060,219788,260611,263711,287245,19159,161444,210125,210128)

select distinct typ from getproducts1 where dept='Reloading' and brand='FEDERAL AMMUNITION' group by typ order by sort_position

select web_url, picture_id from tb_web_taxonomy a left join tb_styles b on (a.category_style=b.style) where dept='Reloading' and typ='Primers' and subtyp_1='EMPTY' and site = 'sportsman'

select web_url from tb_web_taxonomy with (nolock) where dept='' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 301579 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 301579 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=301579

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 301579 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=301579  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=301579 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 136843 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 136843 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=136843

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 136843 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=136843  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=136843 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 204612 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 204612 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=204612

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 204612 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=204612  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=204612 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 209503 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 209503 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=209503

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 209503 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=209503  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=209503 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 252756 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 252756 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=252756

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 252756 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=252756  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=252756 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 19373 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 19373 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=19373

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 19373 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=19373  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=19373 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 246661 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 246661 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=246661

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 246661 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=246661  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=246661 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 19238 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 19238 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=19238

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 19238 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=19238  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=19238 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 133413 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 133413 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=133413

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 133413 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=133413  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=133413 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 163723 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 163723 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=163723

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 163723 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=163723  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=163723 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 164589 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 164589 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=164589

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 164589 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=164589  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=164589 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 218020 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 218020 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=218020

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 218020 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=218020  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=218020 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 219957 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 219957 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=219957

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 219957 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=219957  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=219957 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 250035 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 250035 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=250035

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 250035 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=250035  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=250035 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 295085 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 295085 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=295085

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 295085 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=295085  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=295085 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 19177 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 19177 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=19177

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 19177 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=19177  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=19177 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 104501 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 104501 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=104501

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 104501 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=104501  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=104501 and status='A' and site = 'sportsman'

select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold
			from tb_skus a with (nolock)
			left join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id) 
			where a.style_id = 250030 and e.store_id = 10 
			group by a.style_id, e.qc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 250030 and b.contact_id=22620 and (e.qoh + e.qc) >= 1
	and e.store_id = 27 and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)

select * from bulkitems where bulk_id = ? and site is NULL

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:55:07' and
end_date >= 'May 20, 2024 14:55:07'
and store_id=10 and style_id=250030

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 250030 
and (a.start_date<= 'May 20, 2024 14:55:07' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:55:07'
order by a.promo_id desc

select * from tb_product_reviews with (nolock) where style_id=250030  and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock) where style_id=250030 and status='A' and site = 'sportsman'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/category.cfm/CurrentPage/10/sportsman/gift-guide/brand/FEDERAL%20AMMUNITION/order_by/min_price%20desc
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=/CurrentPage/10/sportsman/gift-guide/brand/FEDERAL AMMUNITION/order_by/min_price desc
PATH_TRANSLATED=E:\inetpub\wwwroot\category.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=8463
cftoken=50a49935572a70f9-E992C6FB-C2A7-5789-BC5C9D32C922A064
hitcount=1
lastvisit={ts '2024-05-20 14:55:05'}
timecreated={ts '2024-05-20 14:55:05'}
urltoken=CFID=8463&CFTOKEN=50a49935572a70f9-E992C6FB-C2A7-5789-BC5C9D32C922A064

Cookie Variables:
CFID=8463
CFTOKEN=50a49935572a70f9-E992C6FB-C2A7-5789-BC5C9D32C922A064
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
USERNAME=
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=8463
cftoken=50a49935572a70f9-E992C6FB-C2A7-5789-BC5C9D32C922A064
cs=/category.cfm/CurrentPage/10/sportsman/gift-guide/brand/FEDERAL AMMUNITION/order_by/min_price desc
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_8463_50a49935572a70f9-E992C6FB-C2A7-5789-BC5C9D32C922A064
strarray=Array (0)
urltoken=CFID=8463&CFTOKEN=50a49935572a70f9-E992C6FB-C2A7-5789-BC5C9D32C922A064

URL Parameters:
CLEARANCE=
CurrentPage=10
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
PAGETYPE=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WEB_TAXONOMY_ID=
WHATSNEW=
brand=FEDERAL AMMUNITION
order_by=min_price desc
sportsman=gift-guide